You are here: Main Menu > I. Interface Menu > 7. External System > 7. ESI Open AR

ESI Open AR

The ESI Open A/R function is used to export open customer balances as of the current date.

1. Follow the common External System Interface (ESI) overview and instructions found in the ESI menu overview.

2. When you first enter the ESI Open AR option command options will appear:

Create Open AR ESI(X) – Select Create Open AR ESI(X) to create an open AR ESI file.
Exit – Select Exit to exit and return to the Interface menu.

Select Open AR ESI(X).

If the file name and type selected already exist, the following message will display: "Warning: File already exists!!! Continue? No/Yes."

Select no to return to the command options.
Select yes to create a new file with the same name that already exists.

3. The following message will display: "Print report? No/Yes"

Select no if you do not want to print the report
Select yes to print the report

4. The following message will appear: "Create a delimited ASC file? No/Yes."

Select no to create a DBF file only. Command options will appear allowing you to print or choose from a set of other print options.
Select yes to create a DBF file and an ASC file.

Select the appropriate option.

Two DBF files will be created ARMMDDYYYY.dbf and AR_Last.dbf in the Shared \NetYield\Data\Company Name\ESI Outbox folder. The ARMMDDYYYY.dbf file is the ESI Open Account Receivables balance file for the current date with MMDDYYYY equal to the current date. The AR_Last.dbf is a copy of the current file. If an ASC file was created the name will be ARMMDDYYYY.asc and will be in the Shared \NetYield\Data\Company Name\ESI Outbox folder.

5. If you selected yes in Step #3 to print an ESI Open A/R report command options will appear allowing you to print or choose from a set of other print options.

The following information will print:

Bill to – The bill-to customer ID
Billing-Customer – The bill-to customer name
Customer Name – The customer name
Ship To – The customer ship-to ID
Invoice – The transaction number
Type – The transaction type:

Date – The transaction date
Terms – The payment terms
Class – The customer class
Sales – The sales rep ID
Broker – The broker ID
Amount – The transaction amount.
Total – The total open receivable balance per customer.

The following information will be exported from the system:

Field Name	Description	Type
BILLTOID	The bill-to customer ID	C 6
BILL_NAME	The name of the bill-to customer	C 40
SHIPTOID	The customer ship-to ID	C 6
INVOICE	The transaction number	C 6
TYPE	The type of transaction: IN – Invoice CR – Credit invoice CM – Credit memo DM – Debit memo CA – Cash application FC – Finance charge HI – Hand prepared invoice	C 2
DATE	The date of the transaction	D 8
TERMS	The payment terms	C 2
CLASS	The customer class	C 2
SALESMAN	The sales rep ID	C 2
BROKER	The broker ID	C 6
AMOUNT	The open balance for the transaction	N 10, 2
ORIG_AMT	The original balance before applying payments	N 10, 2
OLD_BILLTO	The old bill-to ID for the customer	C 6

Security Required : Receivables - Receivable Reports